package vip.xiaonuo.smzq.modular.dictionary.mapper;

import org.apache.ibatis.annotations.Select;
import vip.xiaonuo.smzq.modular.dictionary.entity.Cb14Kcp;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * 矿产品 Mapper
 *
 * @author eomer
 * @since 2024-02-21
 */
@Mapper
public interface Cb14KcpMapper extends BaseMapper<Cb14Kcp> {
@Select("select CONCAT (kcdm,'*',kcmc) as results FROM kcl_cb14_kcp GROUP BY kcdm ,kcmc ORDER BY results")
    List<String> getKcmcList();
}
